View Single Post
 
Old 10-22-2021, 11:10 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Quote:
Originally Posted by Nednil View Post
A BIG THANK YOU! The problem was that the numbers were stored as text and there is a convert text to numbers under the data tab. I never thought of the numbers would be stored as text.
If you don't apply manual cell alignment , text is aligned left and numbres right, so you can see immediately what is text or not
Reply With Quote