Using TEXT Function in Excel

  • Thread starter Thread starter Melwyn Fernandes
  • Start date Start date
M

Melwyn Fernandes

Hi,
I want to insert a value "02-03" into a cell.
However, EXCEL treats this value as a DATE value
and converts the same to 02-Mar.

In Windows NT we handled this problem by using the
the following function.
=TEXT("02-03","00000")

On migrating to Windows XP, this cell formatting
fx has gone for a toss. The value displayed in the
cell is 38048.

Please help me out with this. I need to use the TEXT
fx itself.

Regards
Melwyn
 
Hi Melwyn

One way is to enter a single apostrophe '
prior to entering "02-03" (without quotes)

Another way is to format the cell as "Text"
*prior* to entering "02-03" (without quotes)
 
Hi Melwyn

No need for a formula
Why don't you type a apostrophe before it?

'02-03

Or format your cell as text before you enter the date
 
Melwyn ,

These work

'02-03

that is preceded by an apostrophe

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi
What effect are you looking for? If you just want to display 02-03 (without the quotes) then you can simply enter '02-03 - ie start it with an apostrophe OR format the cells as text and enter 02-03. If you want the quotes then just enter it that way ie "02-03".

Does any of this help?
 
Back
Top