Posted to microsoft.public.excel.misc

Beans

external usenet poster

Posts: 15

TEXT function with unusual results

When trying to convert numbers to text using the TEXT function SOME values
are putting in additional numbers. The formula I'm using is TEXT(A1,A1). The
problem replicates. See below. Does anyone know what is happening? Thanks.

735 735 735 735
736 736 736 736
805 88055 888805555 88888888055555555
814 814 814 814
828 828 828 828
830 83830 838383830 83838383838383830
832 832 832 832
836 836 836 836

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
trying to change Proper function results to text?	Arlene	Excel Worksheet Functions	1	August 23rd 06 09:45 PM
Unusual Request...	LewisAire	Excel Discussion (Misc queries)	0	July 31st 06 12:08 PM
Please help with unusual request?	AWA	Excel Discussion (Misc queries)	4	December 26th 05 08:13 PM
Unusual data format	Salty	Excel Worksheet Functions	2	November 3rd 05 12:40 PM
in excel how to display results of a function and text in the sam.	ez123	Excel Worksheet Functions	3	November 19th 04 01:16 PM

All times are GMT +1. The time now is 07:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us