Scribd
Upload
82 views5 pages

Excel TEXT Function Formatting Guide

The document discusses using the TEXT function in Excel to format dates from mm-dd-yyyy to mmmm d, yyyy and to concatenate time and date values. It also provides examples of using TEXT to convert mobile numbers in scientific notation to standard formats and display the current date as a formatted string.

Uploaded by

Poornima CN
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
82 views5 pages

Excel TEXT Function Formatting Guide

The document discusses using the TEXT function in Excel to format dates from mm-dd-yyyy to mmmm d, yyyy and to concatenate time and date values. It also provides examples of using TEXT to convert mobile numbers in scientific notation to standard formats and display the current date as a formatted string.

Uploaded by

Poornima CN
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

want to convert the format to - “mmmm d, yyyy” using the TEXT function

in Excel.

Date Formatted Date


02-01-2019 February 1,2019

TEXT Function Syntax is =TEXT(value, format_text)


and C respectively. We want the values of Time and
Date column to appear together in column C.

Time Date Time Date


9.00.00 PM 10/18/2018 9.00.00 PM 10/18/2018
10.00.00 PM 10/18/2018 10.00.00 PM 10/18/2018
11.00.00 PM 10/18/2018 11.00.00 PM 10/18/2018
12.00.00 AM 10/18/2018 12.00.00 AM 10/18/2018
1.00.00 AM 10/18/2018 1.00.00 AM 10/18/2018
2.00.00 AM 10/18/2018 2.00.00 AM 10/18/2018
3.00.00 AM 10/18/2018 3.00.00 AM 10/18/2018
4.00.00 AM 10/18/2018 4.00.00 AM 10/18/2018
The below table shows the scientific notation of a list of mobile numbers with their
country codes. We want to use the TEXT function in Excel to convert the mobile
numbers into proper format.

Name Mobile No. Mobile No. (correct


format)
A 9.18E+11 917646000000
B 9.19E+11 918536000000
C 4.16E+11 415686000000
D 2.29E+11 229476000000
E 9.18E+11 917539000000
F 6.17E+11 617037000000
We want to display the present day and date using the TEXT function in Excel.

Today is Sunday 20 Aug, 23y

You might also like