Ending zero

A user of mine pulls up a spreadsheet where the format of a column is in
numeric format. She needs to change it to text but when she does that it
cuts off the 0 if the cell is 23.30. We need to keep that ending 0. She has
too many records to sit there and go back to and add the zero manually. I
tried custom formatting which works, but when she does the mail merge in word
it doesn't recognize the custom formatting and cuts off the 0. Only way it
recognizes in word if formatted text HELP!!!!!

try the Text() function
=text(A1,"0.00")
in a helper column

"RAB" wrote:

> A user of mine pulls up a spreadsheet where the format of a column is in
> numeric format. She needs to change it to text but when she does that it
> cuts off the 0 if the cell is 23.30. We need to keep that ending 0. She has
> too many records to sit there and go back to and add the zero manually. I
> tried custom formatting which works, but when she does the mail merge in word
> it doesn't recognize the custom formatting and cuts off the 0. Only way it
> recognizes in word if formatted text HELP!!!!!

Select the column and use the Increase Decimals tool to get two decimals
Equivalent is select and use Format|Cells, number ->2 decimals
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"RAB" <RAB@discussions.microsoft.com> wrote in message
news:7558DADC-E89F-40D3-B8DA-203519C15C2A@microsoft.com...
>A user of mine pulls up a spreadsheet where the format of a column is in
> numeric format. She needs to change it to text but when she does that it
> cuts off the 0 if the cell is 23.30. We need to keep that ending 0. She
> has
> too many records to sit there and go back to and add the zero manually. I
> tried custom formatting which works, but when she does the mail merge in
> word
> it doesn't recognize the custom formatting and cuts off the 0. Only way
> it
> recognizes in word if formatted text HELP!!!!!

Thank you so much that worked. Having a brain fart should have known that.
:-)~

"bj" wrote:

> try the Text() function
> =text(A1,"0.00")
> in a helper column
>
> "RAB" wrote:
>
> > A user of mine pulls up a spreadsheet where the format of a column is in
> > numeric format. She needs to change it to text but when she does that it
> > cuts off the 0 if the cell is 23.30. We need to keep that ending 0. She has
> > too many records to sit there and go back to and add the zero manually. I
> > tried custom formatting which works, but when she does the mail merge in word
> > it doesn't recognize the custom formatting and cuts off the 0. Only way it
> > recognizes in word if formatted text HELP!!!!!